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` = 1048525 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048525 [ RunTime:0.002672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620760,276956,101110,244083,895583,280069,500262,1030091,239076,1000740,617786,140834,678712,342296,40656,557400,141578,403374,268641,406306,25136,930843,485698,885063,785355,128011,822452,198947,575559,756161,155795,729861,684636,435226,191320,196605,58924,291892,9467,831140,898932,337154,1034490,216706,724494,25879,641776,154806,548372,87907,635466,161842,450360,919204,862337,796718,365018,963879,576994,63337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]