SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453499 LIMIT 1 [ RunTime:0.000872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453499 [ RunTime:0.008997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440177,199470,937607,433794,228726,345659,784740,528613,528404,295910,246956,608735,286678,565941,291280,253932,798173,23666,149640,109877,955599,146541,1002539,657499,717386,311422,296848,448460,399251,560873,676644,574862,280778,626480,270436,768667,931508,612356,238433,1017356,869303,914444,101399,221462,522223,524271,30568,562405,176047,233788,856950,329241,107216,864016,969601,494316,664124,962703,197438,799701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003544s ]