SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580016 LIMIT 1 [ RunTime:0.000772s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580016 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809312,276527,747727,528604,765343,1044149,356976,16288,33440,769014,306893,965423,930626,702472,393641,704307,475955,1012043,409256,353804,385908,344304,132571,320636,269262,188917,706102,534792,78966,557441,592436,895714,1025638,370622,108672,1018254,205977,913028,870450,267445,699043,302723,221980,435643,647031,706158,1047437,414586,78914,309772,89816,80945,154031,813799,736124,484380,792186,1042269,605861,862519) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001167s ]