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` = 469856 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469856 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501276,491026,568346,962871,985321,248790,647878,814508,357015,961236,497187,60972,456697,337869,639424,759692,8429,295366,251888,603122,25094,8287,738409,632159,615774,544272,996634,474776,809320,744084,74814,537584,855677,570584,749488,261431,447864,773761,600937,845289,947943,120529,987803,389086,842598,992215,39549,496386,396366,322667,892328,916923,383091,162908,104838,144805,211599,362124,954387,964968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]