SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44856 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44856 [ RunTime:0.002548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831039,578997,667766,470375,930494,428491,1000208,589412,1000341,410404,250829,412813,985073,1026489,962624,574000,242591,45306,519330,97656,280204,670341,966645,389712,251097,956566,560840,961868,693956,1004922,163616,331506,135365,702941,505326,225793,79877,981420,258745,29870,79421,21379,860108,621869,609412,755499,878204,4132,454027,20359,821855,177567,888767,577525,510341,541405,596897,386631,674330,335476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001063s ]