SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112804 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112804 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662598,208344,580753,87131,727268,245457,118391,822634,543179,745699,543176,292962,146304,1016591,888332,268301,209700,929149,717079,355583,367720,762921,66723,627138,412960,178235,5109,761096,447896,801446,253893,349443,853827,661192,348578,2529,361597,653174,583100,1008371,79565,1010807,139575,82259,1002450,257904,6714,354370,232227,208687,356064,1270,889618,307779,113207,505894,758940,761987,88045,97625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002833s ]