SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474707 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474707 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714840,1008254,67573,268243,497405,422696,590077,512966,802038,983741,1042790,1028063,604019,806538,999758,583299,385512,445988,846215,973247,51832,363020,509151,386844,1016664,1008445,807728,553360,363646,445668,517700,496346,185776,137968,953450,334286,787047,471558,407414,558180,623541,946450,968623,443490,315636,735135,172645,661275,827,333207,782380,880894,221375,125979,71988,137178,292876,1008195,1025831,674075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]