SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255501 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255501 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160800,679152,1014924,948405,887977,154455,701666,728630,84837,312014,378833,363128,709022,776670,303903,616821,998122,473573,952472,932064,986259,203797,70692,836662,1025654,81602,399558,313662,627167,370121,390288,755528,305293,50896,334039,30833,1024409,238236,475587,340225,533898,695463,704927,518634,587965,142605,536889,445620,880817,349359,676902,284453,624499,760700,188601,567730,458052,404650,650359,362259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]