SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402404 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402404 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990022,584994,682774,70052,112072,599753,687191,923565,711048,800072,255212,78360,348891,286039,413262,308321,906214,25352,652067,1010444,708627,606783,359828,1022104,881140,271872,658190,813904,891023,982324,61459,443176,17193,628170,738487,299727,204432,848728,694306,1030938,235451,449242,511858,806425,447562,690275,43805,614140,822951,412127,796658,802855,910426,1037855,543924,651721,621108,1000333,511392,722049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]