SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510717 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510717 [ RunTime:0.002379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308672,699144,197813,76317,64089,339349,862476,53167,270835,1011917,1046168,255868,842367,284414,954615,757343,1014977,51357,885320,75459,448260,66052,638697,978241,113970,44200,495766,1020094,415759,288967,792947,209965,73324,440547,551649,580403,778004,477552,1021968,843288,456853,264392,116899,886713,954201,83266,152942,222601,779553,482065,243798,636677,158273,794835,178725,847286,440626,323462,554230,770425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]