SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405615 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405615 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67672,359137,104535,510517,277171,561143,647190,776456,993880,474604,328952,463581,939416,569300,500967,614118,15763,479558,860430,767226,441358,991437,795104,662319,142422,1025977,500510,206620,518247,876504,528182,322807,1048736,107770,675348,538785,282434,275682,881062,354707,441034,742563,134331,482673,990925,741598,169502,732022,147234,697522,470126,490007,42322,736949,286929,468601,533128,268260,1046059,19857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]