SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108239 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108239 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906104,985941,693122,36901,111557,714074,846619,339692,358817,412660,100738,89414,285083,1001949,455629,614686,969140,115779,114516,562927,169199,784498,752105,736775,350409,529546,695908,536102,451213,734483,132176,203524,113358,648680,999266,857200,1017041,1035535,883735,323270,963352,848035,622272,505386,422980,568458,892276,783837,321851,319381,931840,136683,632376,106618,824428,239411,921257,1002363,1048610,229264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]