SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294970 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294970 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986626,850121,123021,229177,311478,326552,765024,161178,653268,513911,757720,807245,412268,874516,911995,214149,216959,63266,740279,688314,15688,878644,471083,269173,293657,403782,95973,401239,445172,140765,887119,964667,836900,501948,96595,1038544,1016950,519210,451483,475542,38572,737858,1003996,445792,124346,919350,217834,666543,850602,109462,398067,189755,815724,51660,155721,485041,78944,66736,738258,635843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]