SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105894 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105894 [ RunTime:0.004547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496625,401738,4986,403784,260776,286380,337371,377148,534094,938738,791562,561612,739645,974708,670313,990549,808906,997955,151589,517786,366277,956159,618856,118718,701905,860591,230442,243116,972328,929758,718496,1022114,689906,802287,505889,612333,620612,894010,319588,196909,852052,949173,904746,120123,497539,362172,413636,168537,113816,641549,742929,1043597,541749,764298,1038401,1027068,610593,143120,557623,747173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]