SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 895413 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 895413 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28038,640210,679775,363585,405132,82157,236467,728580,481513,158925,52106,118352,724246,45999,883992,804999,480581,2561,1010184,1038403,443522,25340,93785,936016,118056,65865,1001550,659191,236376,221006,72954,362195,154736,244688,690873,950739,682956,450909,582814,736944,906596,595406,168950,718150,216147,931339,42113,808601,24438,375972,602822,772316,842959,788680,744023,395423,1012827,719535,832376,10292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 895413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 895413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]