SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810183 LIMIT 1 [ RunTime:0.000838s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810183 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (475565,808917,728697,186090,275574,744063,632714,1032040,626522,501064,291178,742489,650019,705058,272546,445856,41854,254735,939223,126443,991140,190023,415060,1041279,923906,723033,1007099,614707,317991,460289,744257,846673,619109,1023171,127552,6403,1022653,771398,985055,524786,179320,602016,556437,796389,605377,992246,711432,205123,832984,844392,477017,46882,247598,540195,637793,116065,415480,527725,661702,195550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001635s ]