SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001880s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502765 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502765 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580201,388563,311612,127703,114089,57626,636828,167420,502189,1007417,717591,786197,994155,207144,670709,402457,817888,998772,39534,398635,924721,526837,942893,117178,181428,203630,988160,10156,819605,111498,158536,216626,217124,215799,207708,632077,493968,725444,83257,371903,397769,516767,443091,1042019,1006863,502137,38705,826834,380414,397714,739795,365932,867717,734986,173830,117684,131634,286448,464064,399327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]