SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394806 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394806 [ RunTime:0.003004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121783,81306,487454,8542,880827,1047628,283906,37234,653485,549546,800535,721343,491802,48560,234003,263175,1021145,595408,1003301,682374,600989,491887,649700,349219,866256,953838,801329,199694,252285,173552,33379,266264,821859,521739,51792,660977,403327,877833,848143,692748,719990,252637,312414,673815,963788,853597,382554,483743,705383,226651,427424,158094,399284,578197,243432,641987,426848,299462,833803,860066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]