SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453392 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453392 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627352,177184,311772,988205,492430,1030790,628234,766557,809124,1020239,870718,871135,733601,1023200,667020,565902,561903,1030860,741624,761508,419809,133510,128493,432127,242723,55049,875266,1024084,42436,586785,734004,848460,457527,500036,499901,605685,962791,894606,25500,685190,335713,943181,34677,635221,839620,558055,673028,349399,532902,779469,904315,956829,77944,605833,38168,915538,43058,328182,806419,431974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453392 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453392 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]