SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030593 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030593 [ RunTime:0.003783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362436,584721,1018411,112216,967121,605062,612942,406499,794208,152905,655292,820792,131518,22177,712027,996881,940427,1038291,134795,758511,373375,490792,827201,379269,110561,334805,175428,25069,471825,162802,297573,407446,241994,157744,581476,719440,94685,277234,567983,833032,862873,995204,815641,1022877,335129,685766,855162,263465,939568,704891,300828,186294,294193,168818,648453,864155,31780,133472,565113,733878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001328s ]