SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26181 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26181 [ RunTime:0.003238s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492931,561909,241373,804096,313108,101546,169357,262062,62569,298339,161839,719421,420683,329492,728974,415653,546715,895792,309034,276748,871293,920090,240029,126338,537718,487155,394819,195776,834679,191856,816519,520833,906868,250559,788331,768771,858758,68069,574629,594955,939751,862636,941333,180716,778592,81757,158625,889037,3809,481373,977839,480322,413971,552507,381259,615522,305825,702797,639542,89048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]