SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378511 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378511 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97218,179526,930890,189769,755018,565129,828181,428167,768198,876840,866746,485372,257490,434979,652833,383722,641200,876619,498169,869528,554961,496773,744798,319595,384450,824169,139580,672714,867596,818290,509627,995097,525656,266983,980898,435493,427729,339739,173514,438946,597885,934557,265949,30678,377418,809516,844434,1031728,360895,381916,565667,931530,753815,926823,1030250,444280,827997,193332,592268,744692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]