SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419825 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419825 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (852080,314047,346952,927052,83222,590776,141737,160319,738879,477707,526353,953608,820502,191417,230402,200497,349828,448079,29503,67911,343548,220703,978653,803044,632079,950398,173999,400244,852359,381769,210924,914242,569257,604007,963431,791112,496527,845892,820678,947447,556281,159604,243394,629258,559849,635949,139108,208175,790143,764228,348893,934859,101410,326876,274944,457733,868948,681757,808736,165761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]