SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531890 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531890 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437530,876601,10211,457626,430658,976815,150011,9072,536775,909200,47053,35977,156875,487833,796459,323425,756686,368153,278220,1024294,10679,932526,642143,563675,201495,189802,641953,704957,663531,914598,472731,718913,1008715,428254,379653,31249,767568,150450,219564,980487,1036720,508105,277327,479386,786184,773232,676162,380788,203624,587215,983319,174877,285047,305095,458401,874588,1032390,831939,645735,850061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]