SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483508 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483508 [ RunTime:0.002844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765466,304924,577787,563648,810774,239364,54914,486943,849815,781514,84764,488743,48594,874280,203539,109974,651720,842948,143183,224311,308527,189411,316673,372072,1036029,634114,259190,111360,100456,554211,889712,253854,439938,689383,937672,857554,18778,480641,877569,415,1030991,1039276,892354,231202,157980,652521,378790,194122,830689,422196,656055,1045587,582271,605336,986518,795844,486319,203861,193458,518899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006116s ]