SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541135 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541135 [ RunTime:0.002274s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832803,719976,354134,40957,166456,663812,691522,153019,287047,256149,193157,545065,923955,640284,820272,696606,147878,722688,248361,544555,999752,96578,646732,617825,422221,883206,115937,37501,762960,399898,316671,281370,198796,310490,906790,14576,971888,35860,275710,671815,592880,469166,82827,805734,884723,1019400,942920,271271,719659,616687,227682,476216,244077,338412,409049,461944,661675,1034743,72399,781927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002062s ]