SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804611 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804611 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398268,282975,769516,511838,79926,346016,739471,609709,1009930,488869,565927,917683,359968,1023475,554832,591789,416399,412678,307160,752034,267525,335692,810601,711399,552503,506002,667140,646199,379436,103967,113585,466107,812166,905696,617617,674731,342686,363458,119072,641830,953070,467128,468902,490201,976948,166675,725442,925577,420614,782211,61984,470360,908066,849173,934242,191839,792439,137541,968879,688467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001079s ]