SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4364 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4364 [ RunTime:0.002676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82012,174329,54059,419080,389367,52357,321818,726136,731262,42499,152538,692467,814179,731077,156666,436225,173209,878149,758559,165319,191445,44144,13628,955044,51870,38204,4053,598778,724720,154258,813756,253727,646734,815827,626308,282745,87270,38201,1012080,23591,125707,345940,213913,84214,221068,756239,67514,226611,79790,153950,862030,531222,672966,808798,55867,531971,909459,1047415,568354,761929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003070s ]