SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393501 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393501 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187947,373182,441156,707065,817060,932457,997199,1033878,741319,697706,597300,101928,337011,475864,11200,106701,441763,836866,607602,179030,175339,968409,1039390,350944,340900,225161,1031616,839758,359494,483896,372461,226026,636638,954718,501777,210871,38604,317330,496879,695804,329369,926470,885558,652039,350173,674088,998392,119618,755390,1033063,504399,520490,912257,49234,906515,255423,362450,251547,497187,785855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]