SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486099 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486099 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850358,512965,650889,1040943,546777,110778,826505,103855,316810,200900,887404,386647,140156,593850,45113,629094,57470,686595,949303,363587,1006246,507997,320093,455429,673674,1048097,396485,845918,359076,344622,1001350,715362,766455,180353,132268,965337,785860,24923,138812,456303,353930,483018,1039350,259476,539462,102927,809345,688621,36867,923493,941934,951035,531577,439335,1045313,794677,692971,317789,1018154,312217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]