SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59103 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59103 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554258,95829,85142,450010,536485,978814,454056,471112,205020,978902,823401,915665,672412,477558,236050,330533,842691,1015550,316100,53611,574875,1009526,1040005,257991,1005706,912835,425807,301123,206445,259819,189290,629999,375728,943159,103022,805040,203465,975002,408042,122829,748233,763593,386563,664467,944207,991282,1030238,268907,1040592,651927,365949,919304,682204,702050,557085,322578,846831,484614,152000,945322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001107s ]