SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516303 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516303 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116211,781385,462091,530031,538227,566094,103929,451547,385442,837582,135022,620459,218327,167792,634620,160323,295153,268238,838497,109831,1004520,436466,118066,277556,534323,500312,778505,575479,135453,720723,762611,635085,513603,245737,699415,131420,264809,33177,865597,353797,614440,620220,957049,436882,403626,285444,395973,320511,1021851,213826,118719,650070,199038,419169,131936,751207,1008054,574209,914279,202317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001864s ]