SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046406 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046406 [ RunTime:0.004976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458810,20993,875322,126413,639707,357388,488717,201576,407660,759101,947746,808048,843763,233611,32182,835345,418808,666858,438555,509056,652279,615424,95084,609098,187650,614652,70942,683161,930473,763320,969748,156128,762086,130832,119992,232310,85114,143440,78526,454918,300064,910661,527604,671193,582648,513244,604245,142284,547521,85216,53656,623432,599966,618829,740717,78467,945365,700087,37063,30328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]