SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 664515 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 664515 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043796,228378,936821,282652,1017389,710174,315429,293439,532232,581011,759641,308239,402835,201464,489980,98632,272680,650538,931348,653887,199040,540967,295730,629283,56575,392577,1037184,1037608,282057,875926,526258,331930,471374,127795,600029,626208,434927,218535,604149,775348,91570,426642,37763,1011847,294106,904059,1005918,1020143,210101,893238,95937,455880,871545,968823,625148,404665,48961,349244,519465,97660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 664515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 664515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]