SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045243 LIMIT 1 [ RunTime:0.001382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045243 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888619,913447,68821,1023970,865095,723024,317730,491941,68349,764917,797389,886273,484043,745806,831361,685812,732571,244553,829704,536288,280081,156202,22078,294426,548724,501856,998493,820514,846160,400602,917594,1034895,953022,365063,764158,107819,757182,936014,7481,687745,777391,837258,804603,369803,533570,582378,1030488,515748,621142,573049,92877,899784,595087,831497,552330,517080,1013341,784291,831665,483292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001516s ]