SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421528 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421528 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240326,962232,45496,664466,717994,649926,411373,819071,544209,89784,185533,141441,551466,66936,918118,12483,498426,358104,1013492,728649,774866,455010,786070,92833,612181,875112,298329,883180,1033103,199472,931593,386204,581974,400100,608613,28241,194115,170912,993479,480902,559235,964293,866433,712742,1031783,568512,716267,226697,461589,567311,563386,334813,230056,908778,130360,957202,171631,552502,682841,632667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]