SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358038 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358038 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045921,570956,608999,371607,209115,185546,528732,25774,170664,403490,79299,141317,451984,699981,204814,652913,1000224,552949,1043925,813586,814999,85877,248700,172634,203335,216781,514674,471047,260464,851702,987903,801088,58884,687146,685955,769643,905669,1013287,939343,532107,22438,942779,1028837,20196,453548,818330,366478,162550,996189,1029339,471070,233461,599071,1027011,371858,689669,664804,559192,250353,781237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]