SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483613 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483613 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620509,1041994,170153,106560,343927,536505,674043,601767,965270,718880,645627,507559,144137,4428,939847,396670,970788,524133,189970,724828,1043647,176658,177323,341968,1045694,317823,531485,504123,344376,513691,728653,961778,220104,1001217,932380,451590,339169,487356,267178,382884,192386,731618,151518,649113,201896,440389,213260,186622,723088,744867,553197,1024544,946234,1040129,275735,411534,374135,913560,468670,687804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]