SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475152 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475152 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874059,468213,113546,475425,611706,56260,322058,60734,122846,736431,442418,387183,133564,652081,404021,905782,955626,977011,1032010,884822,78531,520720,561117,990593,239756,415109,819911,185428,818372,26612,222751,246334,263697,1031114,872362,748289,645801,664607,205965,79452,143142,176878,488444,763221,108392,202217,514260,922837,823409,63911,887894,342035,812988,739539,427864,828181,691014,465798,1030915,22812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]