SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530073 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530073 [ RunTime:0.003380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569314,706565,424646,65103,862472,80966,696474,204726,257497,735556,179988,246918,888087,777268,38926,815092,732308,734072,585935,1035631,464030,871280,892950,46143,598584,771410,866325,680958,264224,864121,1017793,23053,646400,150485,465858,821864,317990,57648,32813,43197,545888,262673,290971,185368,470054,307227,951469,273232,597641,363832,536778,1011156,481840,451035,875692,364743,248161,414523,834149,469909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]