SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314150 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314150 [ RunTime:0.002604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215422,196065,722204,1018575,1044803,910072,970072,496879,430714,778751,305518,20318,976093,547292,480602,636027,776150,558965,800181,548006,695488,586419,588514,213815,45802,407747,128870,212132,507953,178310,1003509,405869,934459,449964,364544,985442,370914,406679,667902,95534,659618,896324,324689,77751,29799,175250,200029,968067,88088,415988,190149,854744,745777,720705,568758,938101,381565,839325,291424,48347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]