SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030206 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030206 [ RunTime:0.005646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426461,772354,564292,51905,1023854,375055,438683,883187,557564,635767,808864,841268,371753,641011,567123,413085,126871,606438,306433,19308,657289,813417,864750,87782,17215,266566,336840,227210,357013,562812,769611,81616,1034468,991184,844626,493452,675593,353716,225837,188485,827406,371756,146037,565825,126805,125621,890971,309940,811914,756790,309536,951825,900261,483833,660540,140812,805064,32809,903732,277323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]