SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682871 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682871 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189666,272953,416749,214504,919322,152859,555364,517375,685552,196698,1005788,723118,78685,784161,35713,1033223,1029172,318499,510429,890633,435514,600949,998595,699990,748878,561989,975448,201607,1019711,204501,646940,407534,974078,984525,668913,907537,602507,472535,320953,549193,100279,789929,590096,568439,691666,331957,186289,719769,552601,850797,706756,239140,154174,216476,281824,100425,334879,655825,388583,487424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]