SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505676 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505676 [ RunTime:0.001942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551865,141075,478373,812590,303949,77624,791552,901365,173056,667797,892182,318761,656257,296026,374148,651250,740031,645274,644064,774389,181698,573273,363705,966619,198357,430212,647951,134985,410278,972105,281929,410979,112063,823267,1029715,262059,1021644,453855,786837,943821,963091,469091,1048429,569110,174218,1024496,281162,213582,687813,432778,393931,318047,91972,485049,949000,320398,695041,712743,923913,231862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002057s ]