SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26764 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26764 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524752,517941,527004,781107,647266,182253,290807,491419,138486,46635,876823,248811,414734,409808,622530,538795,605714,400178,952484,674361,33230,736481,298566,874189,854056,554797,892134,43257,745513,342921,849617,171636,903644,531111,15879,877979,870762,835111,138158,776941,511057,845991,100677,59177,19521,781748,240256,168092,894000,503722,874244,89634,1001879,420923,528184,449788,127047,99394,201410,287946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]