SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527976 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527976 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018774,888272,466104,945486,40578,123893,310444,66736,504709,616678,651612,80695,213868,190713,632888,442919,758142,785289,308376,343538,174644,662515,343262,827218,529106,294986,327045,426123,322773,509599,161082,180285,895442,142011,418301,848028,196722,712318,794579,883999,716190,557622,223197,346299,316638,346934,445798,306059,12417,796182,651315,218837,788451,781730,676439,191338,730044,421632,519134,414028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]