SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488898 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488898 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120703,435582,726510,473784,851754,554383,553991,466917,199713,541985,121691,341294,327437,540198,240812,615397,428490,856393,348073,322748,795134,315204,232925,720542,114464,566708,832624,433211,267174,570000,827851,110284,961991,748238,819048,379897,433222,247549,205775,540445,974213,449631,567274,723851,399232,794287,466985,214387,307810,695980,4035,955493,402581,647134,809631,1038148,797791,300643,148207,367780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]