SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522003 LIMIT 1 [ RunTime:0.000868s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522003 [ RunTime:0.006802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (668022,350004,112219,745809,99927,18496,742177,597963,682472,830181,216860,221955,478949,800705,63998,672319,868505,718108,645759,379955,926943,782271,838409,668903,908929,811639,743293,832737,849990,118043,826869,149739,508788,785806,965676,425109,982092,324879,601155,617884,341034,542108,591573,842863,353422,545164,356513,746659,276991,648838,951261,1040063,59799,1047152,465274,618197,671759,663291,669741,965112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]