SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563838 LIMIT 1 [ RunTime:0.001885s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563838 [ RunTime:0.001422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014149,446509,750616,107235,772572,400547,910927,898065,837038,23667,472658,699233,161277,141619,749673,288843,583671,426747,144198,402547,581700,345707,441290,1047043,708856,1043842,657927,324441,860494,1036035,757921,659688,536246,282380,890369,1015072,649692,959380,572184,179414,681030,157143,94446,366538,82209,963330,784485,623168,48995,94746,770995,153172,448208,847736,387448,666603,128913,801429,415460,946635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]