SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045478 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045478 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204781,665793,6804,310603,1022304,254161,751039,75885,931368,380235,242032,989365,57305,34352,572317,364140,687053,181953,151722,329718,661847,216391,416753,632569,798618,493499,841434,484004,906807,181703,466064,1038941,879194,883498,774920,772506,706423,790963,2757,547160,377516,819010,490964,232305,444999,481868,60189,445885,447115,961802,522603,872520,165960,663644,382471,810959,826504,542443,652296,982415) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]