SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507300 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507300 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584400,471389,889226,792202,76672,276131,605922,318000,67127,815540,179264,52222,850742,435406,1030106,388265,478545,940101,782361,963414,234121,808507,598673,825140,349324,960879,181557,442130,501133,377709,520808,194029,73077,307677,303002,315382,1000533,578384,917517,617181,878026,709646,972627,190174,769196,116059,427994,449246,423832,1006665,53377,1000245,542644,537397,706430,964572,637264,30135,1014576,269110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]