SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540614 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540614 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972645,337381,62734,715127,608218,559908,653633,544691,141991,682637,861578,297997,641912,603919,565008,714942,469676,666111,358322,715926,163437,640470,671682,996091,478250,556905,201829,902142,145566,697352,548326,22881,564519,241147,986519,917115,495638,828668,947093,225331,362236,135480,5010,18965,997709,764388,860966,327912,708218,316825,748976,198970,147947,517221,523794,874644,148862,497383,1030490,643440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]