SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014019 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014019 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209328,352167,931559,688446,149064,310565,426822,6598,694653,580667,829069,293407,500224,681499,95952,583129,78983,586839,208796,173890,13130,629877,1044625,898164,854886,726509,724265,508465,242725,394332,682315,664022,244082,103468,496259,581466,128018,484670,511042,149116,131500,463927,821552,710861,130147,33526,1041761,9471,58539,226806,563126,841646,278424,925474,827729,610843,250160,62965,994298,84071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]