SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438008 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438008 [ RunTime:0.004660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204741,716198,30755,443103,651452,890587,837649,148536,924671,73008,44504,373363,918513,810196,622090,588103,676183,422335,413263,1669,502177,76228,540711,879449,186638,428043,166738,484390,313360,472244,498529,801228,697969,861223,159282,1048149,627649,808152,1037526,619426,768917,1021011,621900,251343,540974,979906,401992,888892,775156,1001889,202481,10836,158640,494962,956013,93431,1003964,994771,318716,195884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]