SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016017 LIMIT 1 [ RunTime:0.001337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016017 [ RunTime:0.002511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430124,459080,138566,1030312,527636,6363,570172,628577,995380,199235,393014,1024628,965539,1034049,295989,408359,352383,976621,413672,431404,935990,234356,344315,695681,798094,466669,842322,366877,776771,323016,735067,256101,201746,203225,166018,1009621,1030068,345250,670844,170469,119081,948590,959305,873631,576018,272750,564944,749463,597230,560589,66999,239076,545742,814726,465979,366569,669618,84782,415006,527539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]