SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9643 LIMIT 1 [ RunTime:0.000956s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9643 [ RunTime:0.002273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219110,1004675,1011293,841669,134909,765956,446135,928432,197814,466034,472249,417346,927565,435756,529727,360907,501978,816449,1030267,340795,374190,826960,476414,779814,571482,1024962,379943,505398,24439,1046874,139721,1025525,517559,599938,313433,1004639,814582,109529,520893,60230,389685,849497,903615,194206,368730,1016536,917668,331882,875828,319918,381890,142709,875490,181897,251022,371532,278885,1026106,1025457,341020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001056s ]