SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381234 LIMIT 1 [ RunTime:0.001466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381234 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355659,567884,536562,752112,649739,550540,8609,435117,7136,559619,1017903,78884,1005414,701944,802518,410285,515988,367448,335282,385716,1009065,95670,101400,370370,75555,257783,129809,440919,318788,135311,724758,801777,933613,196052,860568,338431,952060,670338,11876,203548,804182,834427,770110,580169,280444,434304,842264,872256,533691,84338,945780,490202,351681,960848,238509,551957,653761,955228,858684,964657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001260s ]