SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196818 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196818 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917654,733022,321560,839029,717937,117614,145083,1046413,718289,788283,188999,753130,395144,523411,957527,697172,1021687,701505,128757,472821,200256,141960,969400,993736,537019,400838,508284,881478,225577,672580,757847,42058,825193,421289,63070,264899,572691,734823,42699,561297,926545,241705,211048,620573,334281,719397,208769,449996,307854,1016980,547104,981988,852618,414312,313725,607118,1040221,805603,362553,937776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]