SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559404 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559404 [ RunTime:0.002857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532872,372117,333275,639196,171981,857978,920007,885138,848774,281120,928142,256588,209444,582162,768231,546321,1044823,410918,72000,519313,228299,1020992,553558,29423,684021,897781,316543,450569,781308,250055,819963,63459,717636,898749,600093,41050,741310,854524,3881,914531,155045,309321,790474,495282,151309,106059,956949,902768,47281,714263,410522,938943,432493,913212,226221,422000,663384,117909,135351,334001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]