SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103283 LIMIT 1 [ RunTime:0.001058s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103283 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535107,926390,474214,575986,52693,121931,96847,1024,252347,541134,842910,879734,189209,362695,326795,424016,855032,515127,838238,556484,528470,78762,42019,326767,988111,351097,635852,830376,259667,754889,81289,732520,376332,702077,156064,760944,158355,57437,970078,568461,707765,19836,953509,652601,119361,401672,638200,589106,699649,827836,629557,784954,962699,567623,576094,335565,414088,372059,969949,856251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]