SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003223 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003223 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018953,840002,520104,77413,188846,566207,788424,664724,235676,962627,912473,677873,197400,873865,176370,33514,808161,357571,426539,429081,1033328,461194,497096,841277,592349,427896,731787,188357,804325,629654,733076,461658,233164,296889,181808,624283,617122,700146,556665,103362,529007,559521,525871,25680,656511,742935,569077,710324,817451,119475,493675,952781,663832,745634,32149,308236,710492,431702,317604,394668) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]