SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021843 LIMIT 1 [ RunTime:0.000742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021843 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53014,792508,649937,533057,155470,389066,969066,343719,246040,177495,916308,90609,993846,521655,492453,74198,1025027,530730,993893,507915,717474,457616,1047749,170403,414850,81182,527042,224197,740269,793666,197531,629613,258367,422463,327301,49010,967520,168015,602917,108633,234084,36612,168144,858932,686014,650311,298304,159606,569360,709432,150270,158663,192920,885590,940535,586657,491551,899162,88440,808184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]